vaccination_paracetamol
Table: vaccination_paracetamol
The vaccination_paracetamol table records whether paracetamol was given to a child during penta (1/2/3) vaccination.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| id | int(11) | NO | Primary key identifying each record |
| vaccinationRecordNum | int(11) | NO | References the vaccination record |
| isParacetamolGiven | tinyint(1) | YES | Flag indicating if paracetamol was given (0 = No, 1 = Yes) |
Indexes
fk_vaccination_vaccination_paracetamol— Index onvaccinationRecordNum
Foreign Key Relations
vaccinationRecordNum → vaccination.vaccinationRecordNum
Usage Notes
- Tracks whether paracetamol was administered to children during immunization.
- Useful for monitoring post-vaccination care practices.